Tabela ExternalOrgUnit

Definicja tabeli ExternalOrgUnit

Name

ExternalOrgUnit

Code

ExternalOrgUnit

Comment

PL: Definicja zewnetrznej jednostki organizacyjnej
EN: External organization unit definition


Lista kolumn tabeli ExternalOrgUnit

Name

Code

ExternalOrgUnitID

ExternalOrgUnitID

ExternalOrgUnitTypeID

ExternalOrgUnitTypeID

OrgUnitFunctionMHID

OrgUnitFunctionMHID

ContractorTypeID

ContractorTypeID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

CustomerContractNo

CustomerContractNo

OrderingCompanyStatisticalNo

OrderingCompanyStatisticalNo

OrderingOrgUnitType

OrderingOrgUnitType

Active

Active

Comments

Comments

StatCode

StatCode

OrgUnitEntityName

OrgUnitEntityName

OrgUnitCellName

OrgUnitCellName

StatCode1stPart

StatCode1stPart


Kolumna ExternalOrgUnitID tabeli ExternalOrgUnit

Definicja kolumny ExternalOrgUnitID tabeli ExternalOrgUnit

Name

ExternalOrgUnitID

Code

ExternalOrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalOrgUnitTypeID tabeli ExternalOrgUnit

Definicja kolumny ExternalOrgUnitTypeID tabeli ExternalOrgUnit

Name

ExternalOrgUnitTypeID

Code

ExternalOrgUnitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrgUnitFunctionMHID tabeli ExternalOrgUnit

Definicja kolumny OrgUnitFunctionMHID tabeli ExternalOrgUnit

Name

OrgUnitFunctionMHID

Code

OrgUnitFunctionMHID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorTypeID tabeli ExternalOrgUnit

Definicja kolumny ContractorTypeID tabeli ExternalOrgUnit

Name

ContractorTypeID

Code

ContractorTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ swiadczeniodawcy


Kolumna Code tabeli ExternalOrgUnit

Definicja kolumny Code tabeli ExternalOrgUnit

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli ExternalOrgUnit

Definicja kolumny ShortName tabeli ExternalOrgUnit

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli ExternalOrgUnit

Definicja kolumny FullName tabeli ExternalOrgUnit

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli ExternalOrgUnit

Definicja kolumny Description tabeli ExternalOrgUnit

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna CustomerContractNo tabeli ExternalOrgUnit

Definicja kolumny CustomerContractNo tabeli ExternalOrgUnit

Name

CustomerContractNo

Code

CustomerContractNo

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna OrderingCompanyStatisticalNo tabeli ExternalOrgUnit

Definicja kolumny OrderingCompanyStatisticalNo tabeli ExternalOrgUnit

Name

OrderingCompanyStatisticalNo

Code

OrderingCompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna OrderingOrgUnitType tabeli ExternalOrgUnit

Definicja kolumny OrderingOrgUnitType tabeli ExternalOrgUnit

Name

OrderingOrgUnitType

Code

OrderingOrgUnitType

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Active tabeli ExternalOrgUnit

Definicja kolumny Active tabeli ExternalOrgUnit

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Comments tabeli ExternalOrgUnit

Definicja kolumny Comments tabeli ExternalOrgUnit

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StatCode tabeli ExternalOrgUnit

Definicja kolumny StatCode tabeli ExternalOrgUnit

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna OrgUnitEntityName tabeli ExternalOrgUnit

Definicja kolumny OrgUnitEntityName tabeli ExternalOrgUnit

Name

OrgUnitEntityName

Code

OrgUnitEntityName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa jednostki organizacyjnej


Kolumna OrgUnitCellName tabeli ExternalOrgUnit

Definicja kolumny OrgUnitCellName tabeli ExternalOrgUnit

Name

OrgUnitCellName

Code

OrgUnitCellName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa komórki organizacyjnej


Kolumna StatCode1stPart tabeli ExternalOrgUnit

Definicja kolumny StatCode1stPart tabeli ExternalOrgUnit

Name

StatCode1stPart

Code

StatCode1stPart

Data Type

VARCHAR2(12)

Mandatory

No

Comment

Pierwsza czesc kodu resort


Lista kluczy tabeli ExternalOrgUnit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExternalOrgUnit

Definicja klucza Identifier_1 tabeli ExternalOrgUnit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment